USE Contacts
GO
IF (OBJECT_ID('SP_Delete_all_data')IS NOT NULL)
DROP PROCEDURE SP_Delete_all_data
GO

CREATE PROCEDURE SP_Delete_all_data
AS
BEGIN
	DELETE Pers FROM  Personality AS Pers
	DELETE PR FROM PlaceResidence AS PR
	DELETE Pos FROM Position AS Pos
	DELETE Sub FROM Subdivision AS Sub
END
GO